[ROOT] dt FactResellerSale PIVOT DimSalesTerritory.Name+'_'+DimCurrency.Name BY OrderDate.Year() SUM SalesAmount TITLE Reseller sales pr Sales territory country and year (note inclusion of currency for 'safety' reasons)
12 items
| DimSalesTerritory.Name+'_'+DimCurrency.NameId | _SUM | 2022 | 2023 | 2024 | 2025 |
|---|---|---|---|---|---|
| United States, Northwest_US Dollar | 12435076.03 | 1689790.26 | 3471100.00 | 4640534.83 | 2633650.94 |
| Germany_EURO | 1983987.75 | 0.00 | 0.00 | 1098866.54 | 885121.21 |
| United Kingdom_United Kingdom Pound | 4279008.89 | 0.00 | 841757.87 | 2160145.96 | 1277105.06 |
| France_EURO | 490547.63 | 0.00 | 80297.21 | 263416.41 | 146834.01 |
| Canada_Canadian Dollar | 14377925.71 | 1513359.61 | 4822999.98 | 5651305.01 | 2390261.11 |
| France_US Dollar | 4116990.29 | 0.00 | 776826.10 | 2110387.62 | 1229776.57 |
| United States, Central_US Dollar | 7906008.08 | 951240.62 | 2625640.05 | 3005591.32 | 1323536.09 |
| United States, Southeast_US Dollar | 7867415.75 | 1448921.46 | 2815903.57 | 2429279.58 | 1173311.14 |
| United States, Southwest_US Dollar | 18466458.96 | 1893578.22 | 6266006.42 | 7131771.87 | 3175102.45 |
| United States, Northeast_US Dollar | 6932842.17 | 568545.77 | 2443901.88 | 2863937.74 | 1056456.78 |
| Australia_Australian Dollar | 1594334.85 | 0.00 | 0.00 | 847430.73 | 746904.12 |
| _SUM | 80450596.11 | 8065435.94 | 24144433.08 | 32202667.61 | 16038059.48 |
Generated 2025-08-25 15:21:55.186 UTC